home *** CD-ROM | disk | FTP | other *** search
/ PC World 2007 November / PCWorld_2007-11_cd.bin / domácnost a kancelar / opencontacts / setup.exe / {app} / upgrade23to24.sql < prev    next >
Encoding:
Text File  |  2007-08-18  |  1.0 KB  |  61 lines
  1. SET TERM ^;
  2. CREATE TRIGGER "FieldCreateTimeStamp" FOR SECTIONFIELDS
  3. ACTIVE BEFORE INSERT POSITION 0
  4. AS
  5. BEGIN
  6.   NEW.DATECREATE = CURRENT_TIMESTAMP;
  7.   NEW.DATEMODIFIED = CURRENT_TIMESTAMP;
  8. END;
  9. ^
  10. SET TERM ; ^
  11.  
  12.  
  13.  
  14. SET TERM ^;
  15. CREATE TRIGGER "FieldUpdateTimeStamp" FOR SECTIONFIELDS
  16. ACTIVE BEFORE UPDATE POSITION 0
  17. AS
  18. BEGIN
  19.   NEW.DATEMODIFIED = CURRENT_TIMESTAMP;
  20. END;
  21. ^
  22. SET TERM ; ^
  23.  
  24.  
  25. DROP TRIGGER "PeopleRealTimestamp";
  26.  
  27.  
  28. SET TERM ^;
  29. CREATE TRIGGER "PeopleUpdateTimestamp" FOR PEOPLE
  30. ACTIVE BEFORE UPDATE POSITION 0
  31. AS
  32. BEGIN
  33.   NEW.DATEMODIFIED = CURRENT_TIMESTAMP;
  34. END;
  35. ^
  36. SET TERM ; ^
  37.  
  38.  
  39. SET TERM ^;
  40. CREATE TRIGGER "PeopleCreateTimestamp" FOR PEOPLE
  41. ACTIVE BEFORE INSERT POSITION 0
  42. AS
  43. BEGIN
  44.   NEW.CREATEDATE = CURRENT_TIMESTAMP;
  45.   NEW.DATEMODIFIED = CURRENT_TIMESTAMP;
  46. END;
  47. ^
  48. SET TERM ; ^
  49.  
  50.  
  51. DECLARE EXTERNAL FUNCTION FUD_BIRTHDAYBETWEENMONTHDAY
  52.     DATE,
  53.     INTEGER,
  54.     INTEGER,
  55.     INTEGER,
  56.     INTEGER
  57. RETURNS INTEGER BY VALUE
  58. ENTRY_POINT 'BirthdayBetweenMonthDay' MODULE_NAME 'udfoc';
  59.  
  60.  
  61.